Exporting worksheets

Command

Path

Export Worksheet

File (worksheet menu)

File > Export

Vectorworks worksheet files can be exported and read by spreadsheet programs, as well as by some word processing programs. Because these programs have different format requirements, several export formats are available. For example, a tab delimited text file can be opened as a table in Microsoft Word. The following formats are available:

Microsoft Excel (.xls, .xlsx)

Tab delimited text (.txt)

CSV, comma delimited text (.csv)

CSV, semicolon delimited text (.csv)

CSV merge, comma delimited text (.csv)

CSV merge, semicolon delimited text (.csv)

DIF (.dif)

SYLK (.slk)

When exporting to Excel, as much as possible, formatting, images, and formulas are preserved. An alert displays when exact translation isn't possible. Database header rows will have light gray fill, similar to the way they look in the worksheet window. You can export multiple worksheets to Excel format simultaneously with the Publish command; see Batch publishing.

To export a worksheet from a Vectorworks file:

Do one of the following:

Select the command from the File > Export menu.

Open the worksheet to export, and select the command from the worksheet's File menu.

The Export Worksheet dialog box opens.

Click to show/hide the parameters.Click to show/hide the parameters.

Parameter

Description

Worksheet

Specifies the worksheet to export; if the command was executed from the worksheet menu, that worksheet name displays and cannot be edited

Format

Specifies the export format

Export Range

If the command was executed from the worksheet menu, specifies whether to export all rows or only the selected rows; otherwise, all rows will be exported

Recalculate worksheet prior to exporting

Recalculates the worksheet before export

Open file in the default viewer

Automatically opens the exported file in the default viewer application, if available

Specify the name and location of the exported worksheet.

 

Was this page helpful?